�{ TOPIC

I. INFORMATION PROCESSING

1. Computers in an Information Age

1.1. Usage of computers in our society

http://www.crpc.rice.edu/CRPC/GT/cjones/lesind.html

1.2. Electronic data processing

2. Computer Communication and Networking

Telecommunication Networks

http://teleeducation.nb.ca/it/module3/

Web66: A K12 World Wide Web Project

http://Web66.coled.umn.edu/

http://www.microsoft.com/office/intranet/

http://www.hklink.net/

http://www.glink.net.hk/~alexque/hkinternet.html

2.1. Simple concepts and applications of computer communication and networking

http://oneworld.wa.com/htmldev/devpage/dev-page.html

http://www.isl.net.tw/books/html/

3. Files and Databases

3.1. Organization of information:

Concepts of file, record, field, key field

http://www.cs.njit.edu/~leon/105/c9/index.htm

File protection and file security

http://www.mcafee.com/

http://www.symantec.com/avcenter/index.html

http://194.134.5.113/uk/home.htm

3.2. Concepts of database

http://wwwsm.iis.sinica.edu.tw/steven/dbms/index.htm

3.3. Data management

The importance of data being accurate and complete

http://www.srt.com/quicklook.html

4. Operating Modes

4.1. Multi-user and multitasking

Batch processing, real time processing, interactive processing

5. Microcomputer and Applications Software Packages

5.1. Operating a microcomputer system

5.2. Using a word processing package

http://teleeducation.nb.ca/it/module5/word/index.html

Microsoft Word 97

http://www.microsoft.com/office/word/default.asp

5.3. Using a spreadsheet package

http://teleeducation.nb.ca/it/module5/excel/index.html

Microsoft Excel

http://www.microsoft.com/office/excel/default.asp

http://www.j-walk.com/ss/

http://www.pcwebopedia.com/spreadsheet.htm

5.4. Using a database management system

http://aspire.cs.uah.edu/~jonesj/spreadsheet.htm

http://sunsite.univie.ac.at/Spreadsite/spreaded.html

5.5. Using a graphics package

http://teleeducation.nb.ca/it/module5/powerpoint/index.html

5.6. Using Internet

6. Social Issues of the Widespread Use of Computer

6.1. Employment

6.2. Computer ethics and computer crime

http://www.yahoo.com/Computers_and_Internet/Ethics/

http://www.siu.edu/departments/coba/mgmt/iswnet/isethics/biblio/

II. COMPUTER SYSTEMS

7. Basic Concepts of a Computer

http://www2.magmacom.com/~dsleeth/kids/lessons/starter.htm

Introduction to the PC

http://www.mkdata.dk/english/module2a.htm

7.1. Basic concepts

8. Basic Components of Computer System

Hardware & Software definitions and illustrations.

http://www.computerlanguage.com/demo.html

8.1. The functions and the interrelationship of computer system components: central processing unit (CPU), random access memory (RAM), read only memory (ROM), peripheral devices, input/output devices, storage devices, buses

Boot process, system bus, I/O busses, ISA bus, Chip sets, RAM

http://www.mkdata.dk/english/module2b.htm

Drives, Hard disks, Optic storage media, MO and ZIP drives, Tape streamers http://www.mkdata.dk/english/module4a.htm

Floppy Drives, Modems, Monitors

http://www.hardwarecentral.com/hardware/fdrives/

http://www.intel.com/mmx/index.htm

http://www.amd.com/K6/

http://www.cyrix.com/process/prodinfo/6x86mx/6x86mx.htm

http://www.asus.com.tw/indexold.html

http://www.magic-pro.com.hk/

8.2. The central processing unit (CPU) and its interconnected units :

Control unit

Arithmetic and logic unit (ALU)

Registers

CPU, CPU improvements, CPU 5th & 6th generation, Over clocking the CPU's http://www.mkdata.dk/english/module3a.htm

8.3. Basic storage units: bit, byte, word

About data

http://www.mkdata.dk/english/module1a.htm Character tables

http://www.mkdata.dk/english/module1b.htm

8.4. The general characteristics of input, output and storage devices. Relative speeds, reliability, volatility, access method, costs and sizes. Identifying the suitability of the devices for particular tasks

http://www.apple.com/support/

9. Representation of Data within the Computer

http://www.microsoft.com/office/powerpoint/default.asp

9.1. The representation of numeric data

Fixed point representation : sign-and-magnitude, two’s complement

Floating-point representation

9.2. The representation of

alphanumeric data and Chinese characters

Open Chinese for Windows – GOING II

http://www.iis.sinica.edu.tw/LPDA/OpenChinese/eindex.html

http://ag.arizona.edu/~heng/chinese/gb/chinese_diannao.html

10. Computer Operations

10.1. The instruction cycle: fetch, decode, execute

10.2. Machine codes and mnemonics

10.3. The composition and execution of simple machine code programs

11. Programming Languages

11.1. Level of languages

The need for high level languages. The advantages and disadvantages of programming in high/low level languages. The relationships among machine language, assembly language, and high level languages, together with an understanding of the role of translators

11.2. Development of programming languages

12. The Operating System

Relationship between operating system and hardware

http://www.mkdata.dk/english/module6c.htm

Computer Systems

http://www.cs.curtin.edu.au/units/cp501/notes/lect11.html

12.1. The need for operating system

12.2. The functions of an operating system

III. PROGRAMS

13. Algorithms and Design Techniques

13.1. Stepwise refinement as a problem analysis technique

13.2. Problem solving procedures : problem definition, problem analysis, algorithm design, program coding, program testing / debugging and program documentation

http://www.spirit.com.au/ACEC96/papers/carey.htm

http://www.cs.curtin.edu.au/units/cp501/notes/lect81.html

13.3. Program documentation : titles, specification of the problem, algorithms, lists and definitions of variables and files used, annotated program listing, test data, sample output and user documentation

14. Programming

14.1. Knowledge of the high-level language Pascal:

Learning Pascal

http://www.yahoo.com/Computers_and_Internet

/Programming_Languages/Pascal/

http://www.cit.ac.nz/smac/pascal/default.htm

http://home.hkstar.com/~autokim/guides.html

http://www.cs.vu.nl/~jprins/tp.html

http://www.brain.uni-freiburg.de/~klaus/fpc/

Turbo Pascal Programmers Page

http://www.cs.vu.nl/~jprins/tp.html

Pascal Programming OnLine Notes

http://www.cit.ac.nz/smac/pascal/pstart.htm

F.4D Pascal Programming Program 9

http://www.geocities.com/RodeoDrive/6878/mystudent.html

TURBO PASCAL LEARNING CLUB & C LEARNING CLUB

http://home.hkstar.com/~autokim/

Borland Pascal

http://www.inprise.com/pascal/?+

FPK-Pascal Compiler (You can download this Pascal compiler from this site.)

http://sun01.brain.uni-freiburg.de/%7Eklaus/pascal/fpk-pas/

HKCEE Pascal Notes

http://home.netteens.net/~cwswong/stdroom/cepascal/contents.html

TMT Pascal Lite for DOS ( You can download this Pascal compiler from this site. )

http://www.tmt.com/download.htm

Turbo Pascal Programmers' Page

http://www.universal.nl/users/dickmann/pascal.htm

(Some sample HKCEE Exam Model Paper)

http://home.chevalier.net/~watson/comteach/comteach.htm#programming exercises

Constants

http://www.cit.ac.nz/smac/pascal/pas020.htm

http://www.cit.ac.nz/smac/pascal/pas005.htm

http://www.cit.ac.nz/smac/pascal/pas008.htm

http://www.cit.ac.nz/smac/pascal/pas010.htm

Operators

http://www.cit.ac.nz/smac/pascal/pas039.htm

http://www.cit.ac.nz/smac/pascal/pas015.htm

http://www.cit.ac.nz/smac/pascal/pas019.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page1.html

Arithmetic functions

http://www.cit.ac.nz/smac/pascal/pas009.htm

http://www.cit.ac.nz/smac/pascal/pas046.htm

http://www.cit.ac.nz/smac/pascal/pas040.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page2.html

String functions and procedures

http://www.cit.ac.nz/smac/pascal/pas063.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page3.html

Input/output statements

http://www.cit.ac.nz/smac/pascal/pas011.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page7.html

Assignment statements

http://home.netteens.net/~cwswong/stdroom/cepascal/page6.html

Subprogram (procedure only)

Iteration statements

http://home.netteens.net/~cwswong/stdroom/cepascal/page4.html

File handling statements

http://www.cit.ac.nz/smac/pascal/pas056.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page8.html

14.2. Programming techniques:

Structured programming

http://www.davebsoft.com/Teaching/GraphTlk/basadv.htm#Structured

http://home.netvigator.com/~eddie8/

http://home.chevalier.net/~chli/crotn4.htm

http://www.cit.ac.nz/smac/pascal/pas065.htm

http://www.cit.ac.nz/smac/pascal/pas069.htm

User-computer interface

Searching

Sorting

http://www.cs.curtin.edu.au/units/cp501/notes/sorting1.html

http://www.cs.washington.edu/homes/dfasulo/cse142/selsort.html

http://www_ece.eng.wayne.edu/~pdcl/ece561

/assignments/assignment5/node1.html

File handling

http://www.cit.ac.nz/smac/pascal/pas056.htm

http://home.netteens.net/~cwswong/stdroom/cepascal/page8.html

15 Other Teaching Resources:

F.4 Supplementary Notes

http://home.chevalier.net/~watson/comteach/note2.htm

Basic Tests Questions

http://home.chevalier.net/~watson/comteach/comteach.htm

Mock Papers

http://home.chevalier.net/~watson/comteach/mock.htm

Supplementary Notes and Mock Examination Papers

http://spcs.school.net.hk/cs/index.html